{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":196,"n_cols":12,"rows_kept":196,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,3],[80,2,80,3],[99,2,99,3],[118,2,118,3],[137,2,137,3],[156,2,156,3],[175,2,175,3],[194,2,194,3],[195,2,195,4]]}
["Школа",null,"МБОУ СОШ №3",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","И.Г.Михайличенко"]
["Возрастная категория",{"$nulls":3},"12-18 лет",null,"дата",2,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша рисовая с маслом сливочным",205,2,6,24,163,302,17.93]
[]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,5,5,33,190,693,9.17]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты","Апельсины",100,1,0,8,38,null,23]
[{"$nulls":4},"Бутерброд с ветчиной",60,1,11,8,124,6,23.41]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":565},{"$f":"SUM(G6:G12)","v":9},22,73,515,null,{"$f":"SUM(L6:L12)","v":73.51}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с горохом",250,8,6,20,163,138,14.94]
[{"$nulls":3},"2 блюдо","Котлета рубленая из птицы",100,19,20,9,294,498,37.14]
[{"$nulls":3},"гарнир","Пюре картофельное",180,3,8,22,189,520,17.75]
[{"$nulls":3},"напиток","Компот из изюма",200,0,0,27,106,638,5.15]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":780},{"$f":"SUM(G14:G22)","v":33.629999999999995},34.93,101.27000000000001,871,null,{"$f":"SUM(L14:L22)","v":80}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":1345},{"$f":"G13+G23","v":42.629999999999995},56.93,174.27,1386,null,{"$f":"L13+L23","v":153.51}]
[1,2,"Завтрак","гор.блюдо","Котлета мясная,макарныые изделия отварные",280,21,16,39,434,"451/332",50.21]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,15,58,685,2.05]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты","Яблоко",100,0.36,0.12,16.8,88.1,null,19]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":610},{"$f":"SUM(G25:G31)","v":23.66},{"$f":"SUM(H25:H31)","v":16.45},{"$f":"SUM(I25:I31)","v":83.55},{"$f":"SUM(J25:J31)","v":644.6},null,73.50999999999999]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Борщ с капустой и картофелем",250,2,5.2,13.1,106,110,14.94]
[{"$nulls":3},"2 блюдо","Сарделька отварная",100,14,14,4,195,99,43.2]
[{"$nulls":3},"гарнир","Рис отварной",180,4.8,12,47.6,326,511,10.2]
[{"$nulls":3},"напиток","Кисель",200,0,0,40,158,648,6.64]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,0.65,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":780},{"$f":"SUM(G33:G41)","v":23.2},{"$f":"SUM(H33:H41)","v":32.129999999999995},{"$f":"SUM(I33:I41)","v":127.97000000000001},{"$f":"SUM(J33:J41)","v":904},null,80]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":1390},{"$f":"G32+G42","v":46.86},{"$f":"H32+H42","v":48.58},{"$f":"I32+I42","v":211.52},{"$f":"J32+J42","v":1548.6},null,153.51]
[1,3,"Завтрак","гор.блюдо","Птица отварная, рис отварной",280,19,20,48,456,"487/511",58.05]
[]
[{"$nulls":3},"гор.напиток","Чай со сгущенным молоком",200,2,2,26,168,685,7.21]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Огурцы свежие",60,0,0,1,7,null,6]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":570},{"$f":"SUM(G44:G50)","v":23.1},{"$f":"SUM(H44:H50)","v":22.33},{"$f":"SUM(I44:I50)","v":87.75},{"$f":"SUM(J44:J50)","v":695.5},null,73.50999999999999]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Щи из свежей капусты с картофелем",250,7,8,10,136,124,18.21]
[{"$nulls":3},"2 блюдо","Гуляш",100,13,6,4,119,437,41.78]
[{"$nulls":3},"гарнир","Каша рассыпчатая гречневая",180,8,10,41,303,508,10.73]
[{"$nulls":3},"напиток","Напиток лимонный",200,0.1,0,24.2,93,699,4.26]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":780},{"$f":"SUM(G52:G60)","v":31.73},{"$f":"SUM(H52:H60)","v":24.93},{"$f":"SUM(I52:I60)","v":102.47000000000001},{"$f":"SUM(J52:J60)","v":770},null,80]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":1350},{"$f":"G51+G61","v":54.83},{"$f":"H51+H61","v":47.26},{"$f":"I51+I61","v":190.22000000000003},{"$f":"J51+J61","v":1465.5},null,153.51]
[1,4,"Завтрак","гор.блюдо","Сердце, тушеное в соусе, пюре картофельное",280,18,9,22,313,"406/520",54.89]
[]
[{"$nulls":3},"гор.напиток","Напиток кофейный",200,2.5,3.6,28.7,152,692,9.62]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Помидоры свежие",60,0.66,0.12,2.28,14.4,null,6.75]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":570},{"$f":"SUM(G63:G69)","v":23.26},{"$f":"SUM(H63:H69)","v":13.049999999999999},{"$f":"SUM(I63:I69)","v":65.73},{"$f":"SUM(J63:J69)","v":543.9},null,73.51]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Рассольник ленинградский",250,3,4.5,20.1,135,132,22.64]
[{"$nulls":3},"2 блюдо","Плов из птицы",250,14.8,14.8,27.2,308,492,47.8]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.1,0,24.2,124,639,4.54]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":750},{"$f":"SUM(G71:G79)","v":21.53},{"$f":"SUM(H71:H79)","v":20.23},{"$f":"SUM(I71:I79)","v":94.77000000000001},{"$f":"SUM(J71:J79)","v":686},null,80]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":1320},{"$f":"G70+G80","v":44.790000000000006},{"$f":"H70+H80","v":33.28},{"$f":"I70+I80","v":160.5},{"$f":"J70+J80","v":1229.9},null,153.51]
[1,5,"Завтрак","гор.блюдо","Колбаса вареная, капуста тушеная",280,11,18,16,272,"99/214",56.05]
[]
[{"$nulls":3},"гор.напиток","Чай с лимоном",207,0,0,15,60,685,4.01]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2,0,13,65,null,2.25]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Печенье",60,1,0,28,115,null,11.2]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":577},{"$f":"SUM(G82:G88)","v":14},{"$f":"SUM(H82:H88)","v":18},{"$f":"SUM(I82:I88)","v":72},{"$f":"SUM(J82:J88)","v":512},null,73.50999999999999]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с горохом",250,8,6,20,163,139,11.34]
[{"$nulls":3},"2 блюдо","Котлета мясная",100,16,7,4,189,451,41.5]
[{"$nulls":3},"гарнир","Макаронные изделия отварные",180,5,9,34,245,332,15.34]
[{"$nulls":3},"напиток","Компот из свежих яблок",200,0,0,36,142,631,6.8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":780},{"$f":"SUM(G90:G98)","v":32.629999999999995},{"$f":"SUM(H90:H98)","v":22.93},{"$f":"SUM(I90:I98)","v":117.27000000000001},{"$f":"SUM(J90:J98)","v":858},null,80]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":1357},{"$f":"G89+G99","v":46.629999999999995},{"$f":"H89+H99","v":40.93},{"$f":"I89+I99","v":189.27},{"$f":"J89+J99","v":1370},null,153.51]
[2,1,"Завтрак","гор.блюдо","Каша пшенная с маслом сливочным",205,6,8,33,238,302,16.94]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0,0,15,58,685,2.05]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты","Апельсины",100,1,0,9,46,null,23]
[{"$nulls":4},"Бутерброд с сыром",60,1,11,8,124,3,31.52]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":565},{"$f":"SUM(G101:G107)","v":8},19,65,466,null,{"$f":"SUM(L101:L107)","v":73.51}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с макаронными изделиями",250,3,3,10,121,140,11.56]
[{"$nulls":3},"2 блюдо","Голубцы с мясом и рисом",250,17,13,13,250,485,57.53]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток из плодов шиповника",200,0,0,24,94,705,5.89]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":750},{"$f":"SUM(G109:G117)","v":23.63},16.93,70.27,584,null,{"$f":"SUM(L109:L117)","v":80}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Итого за день:",null,null,{"$f":"F108+F118","v":1315},{"$f":"G108+G118","v":31.63},{"$f":"H108+H118","v":35.93},{"$f":"I108+I118","v":135.26999999999998},{"$f":"J108+J118","v":1050},null,153.51]
[2,2,"Завтрак","гор.блюдо","Жаркое по-домашнему",260,18,10,22,290,436,62.31]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,15,58,685,2.05]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Огурцы свежие",60,0,0,2,8,null,6.9]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":550},{"$f":"SUM(G120:G126)","v":20.3},10.33,51.75,420.5,null,{"$f":"SUM(L120:L126)","v":73.51}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Борщ с капустой и картофелем",250,2,5.2,13.1,106,110,14.07]
[{"$nulls":3},"2 блюдо","Птица отварная",100,14,8,0,130,487,46.83]
[{"$nulls":3},"гарнир","Рис отварной",180,4.8,12,47.6,326,511,9.91]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,1,0,31,124,639,4.17]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":780},{"$f":"SUM(G128:G136)","v":25.43},26.13,114.97000000000001,805,null,{"$f":"SUM(L128:L136)","v":80}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Итого за день:",null,null,{"$f":"F127+F137","v":1330},{"$f":"G127+G137","v":45.730000000000004},{"$f":"H127+H137","v":36.46},{"$f":"I127+I137","v":166.72000000000003},{"$f":"J127+J137","v":1225.5},null,153.51]
[2,3,"Завтрак","гор.блюдо","Котлета рубленая из птицы, каша рассыпяатая гречневая",280,27,30,50,597,"498/508",42.65]
[]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,5,5,33,190,693,9.61]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты","Яблоки",100,0,0,17,62,null,19]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F145)","v":610},{"$f":"SUM(G139:G145)","v":34.1},35.33,112.75,913.5,null,{"$f":"SUM(L139:L145)","v":73.50999999999999}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп крестьянский с пшеном",250,3,5,14,116,134,24.79]
[{"$nulls":3},"2 блюдо","Жаркое по-домашнему",250,18,10,22,290,436,46.29]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток лимонный",200,0.1,0,24.2,93,699,3.9]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.64,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":750},{"$f":"SUM(G147:G155)","v":24.73},43.64,83.47000000000001,618,null,{"$f":"SUM(L147:L155)","v":80}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Итого за день:",null,null,{"$f":"F146+F156","v":1360},{"$f":"G146+G156","v":58.83},{"$f":"H146+H156","v":78.97},{"$f":"I146+I156","v":196.22000000000003},{"$f":"J146+J156","v":1531.5},null,153.51]
[2,4,"Завтрак","гор.блюдо","Рыба,тушеная в сметане с овощами, пюре картофельное",280,10,17,24,328,"374/520",56]
[]
[{"$nulls":3},"гор.напиток","Напиток кофейный",200,2.5,3.6,28.7,152,692,8.51]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,2.1,0.33,12.75,64.5,null,2.25]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Помидоры свежие",60,1,0,2,14,null,6.75]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F164)","v":570},{"$f":"SUM(G158:G164)","v":15.6},20.93,67.45,558.5,null,{"$f":"SUM(L158:L164)","v":73.51}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Рассольник ленинградский",250,3,4.5,20.1,135,132,23.33]
[{"$nulls":3},"2 блюдо","Плов из птицы",250,14.8,14.8,27.2,308,492,46.35]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток апельсиновый",200,0,0,24,93,699,5.3]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":750},{"$f":"SUM(G166:G174)","v":21.43},47.95,94.57000000000001,655,null,{"$f":"SUM(L166:L174)","v":80}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Итого за день:",null,null,{"$f":"F165+F175","v":1320},{"$f":"G165+G175","v":37.03},{"$f":"H165+H175","v":68.88},{"$f":"I165+I175","v":162.02},{"$f":"J165+J175","v":1213.5},null,153.51]
[2,5,"Завтрак","гор.блюдо","Запеканка из творога с повидлом",290,18,12,41,415,366,49.4]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,15,58,685,2.05]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты","Банан"]
[{"$nulls":4},"Бутерброд с колбасой в/к",60,8,12,12,201,6,22.06]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":550},{"$f":"SUM(G177:G183)","v":26.2},24,68,674,null,{"$f":"SUM(L177:L183)","v":73.50999999999999}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с рыбными консервами",250,2,5,14,110,142,24.24]
[{"$nulls":3},"2 блюдо","Гуляш",100,13,6,4,119,438,31.98]
[{"$nulls":3},"гарнир","Каша рассыпчатая гречневая",180,8,11,41,303,508,10.76]
[{"$nulls":3},"напиток","Компот из кураги",200,1,0,33,130,638,8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.88,0.65,12.65,65.25,null,3.14]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.75,0.28,10.62,53.75,null,1.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":780},{"$f":"SUM(G185:G193)","v":27.63},22.93,115.27000000000001,781,null,{"$f":"SUM(L185:L193)","v":80}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Итого за день:",null,null,{"$f":"F184+F194","v":1330},{"$f":"G184+G194","v":53.83},{"$f":"H184+H194","v":46.93},{"$f":"I184+I194","v":183.27},{"$f":"J184+J194","v":1455},null,153.51]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F119+F138+F157+F176+F195)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F100=0,0,1)+IF(F119=0,0,1)+IF(F138=0,0,1)+IF(F157=0,0,1)+IF(F176=0,0,1)+IF(F195=0,0,1))","v":1341.7},{"$f":"(G24+G43+G62+G81+G100+G119+G138+G157+G176+G195)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G100=0,0,1)+IF(G119=0,0,1)+IF(G138=0,0,1)+IF(G157=0,0,1)+IF(G176=0,0,1)+IF(G195=0,0,1))","v":46.279},49.41499999999999,176.928,1347.55,null,{"$f":"(L24+L43+L62+L81+L100+L119+L138+L157+L176+L195)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=0,0,1)+IF(L81=0,0,1)+IF(L100=0,0,1)+IF(L119=0,0,1)+IF(L138=0,0,1)+IF(L157=0,0,1)+IF(L176=0,0,1)+IF(L195=0,0,1))","v":153.51}]